alter table jms_dm.dm_mng_thd_flase_send_network_summary_dt
    set tblproperties ('external.table.purge' = 'true');
drop table jms_dm.dm_mng_thd_flase_send_network_summary_dt;
CREATE EXTERNAL TABLE jms_dm.dm_mng_thd_flase_send_network_summary_dt
(

    date_time               string comment '录入日期',
    first_duty_network_code string comment '首责任机构code',
    first_duty_network_name string comment '首责任机构name',
    first_duty_network_type int comment '首责任机构网点类型',
    first_duty_agent_code   string comment '首责任机构代理区code',
    first_duty_agent_name   string comment '首责任机构代理区name',
    all_num                 int comment '总件量',
    first_line_num          int comment '首条轨迹后续更新超时',
    outprov_center_num      int comment '离开所在省份最后中心超时',
    same_center_num         int comment '同一中心停留超时',
    adjacent_track          int comment '相邻物流轨迹更新超时',
    update_time             string comment '更新时间'
) COMMENT '春节不打烊-桃花岛虚假发货明细'
    PARTITIONED BY (
        dt string COMMENT '录入时间')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_mng_thd_flase_send_network_summary_dt'
;